-- phpMyAdmin SQL Dump
-- version 4.1.6
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 08 Kwi 2014, 19:26
-- Server version: 5.5.36
-- PHP Version: 5.4.25

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `artykles`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `ID_ARTICLE` int(11) NOT NULL AUTO_INCREMENT,
  `TITLE` int(11) NOT NULL,
  `CONTENT` int(11) NOT NULL,
  `CREATION_DATE` date NOT NULL,
  `ID_AUTHOR` int(11) NOT NULL,
  PRIMARY KEY (`ID_ARTICLE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struktura tabeli dla tabeli `author`
--

CREATE TABLE IF NOT EXISTS `author` (
  `ID_AUTHOR` int(11) NOT NULL AUTO_INCREMENT,
  `NICK_NAME` text COLLATE utf8_polish_ci NOT NULL,
  `E_MAIL` text COLLATE utf8_polish_ci NOT NULL,
  `REGISTRATION_DATE` date NOT NULL,
  `ID_USER` int(11) NOT NULL,
  PRIMARY KEY (`ID_AUTHOR`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_polish_ci AUTO_INCREMENT=3 ;

--
-- Zrzut danych tabeli `author`
--

INSERT INTO `author` (`ID_AUTHOR`, `NICK_NAME`, `E_MAIL`, `REGISTRATION_DATE`, `ID_USER`) VALUES
(-2147483648, 'Fdsfds', '', '0000-00-00', 0),
(-2147483621, 'krzych', 'fccerekiew@gmail.com', '2014-01-13', -2147483648),
(1, 'Krzysiu', 'karton@o2.pl', '2014-04-02', 2),
(2, 'Krzysiu', 'karton@gmail.com', '2014-02-04', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
